selecting data from multiple DBs - Mailing list pgsql-general

From Giovanni Tummarello
Subject selecting data from multiple DBs
Date
Msg-id 3A126953000880F0@relay4.inwind.it> (added by postmaster@inwind.it)
Whole thread Raw
List pgsql-general
Hello .. on the same machine i have several DBs.. i owuld like to do a query
that joins results from different ones .. is ther eany way to do it in
postgres? i would expect something list

select foo1 from database1.mytable,database2.mytable etc.. ec.

but i have found no way..

i woudl be very surprised if there was no way to do it.. since Postgres has the
UID concept on any record of any database..
thanks for any info

Sincerley
Giovanni Tummarello
tummarel@ascu.unian.it


Fight Spam! Join CAUCE (Coalition Against Unsolicited Commercial Email)
       at http://www.cauce.org/ and tell your Congresspeople how Spam mailings
       hurt you. Help protect genuine Internet commerce: Outlaw UCE Spamming.

pgsql-general by date:

Previous
From: DaVinci
Date:
Subject: Re: selecting data from multiple DBs
Next
From: j.logsdon@lancaster.ac.uk
Date:
Subject: Pivotal system